You download a report, expect a friendly spreadsheet, and receive a file ending in .atomsvc. Double-click it, and your computer responds with the digital equivalent of a blank stare. No rows, no colorful chart, and certainly no helpful button labeled “Make This Normal.”
Fortunately, an ATOMSVC file is not corrupted, dangerous by default, or written in an alien programming language. It is an Atom service document: a small XML-based file that tells compatible software where one or more online data feeds are located. Instead of carrying the report data itself, it usually acts like a map pointing toward the server that provides the data.
This guide explains what an ATOMSVC file contains, how to open it in a text editor, Excel, or Power BI, why common errors occur, and how to export the connected information into a more familiar format.
What Is an ATOMSVC File?
A file with the .atomsvc file extension is an Atom Publishing Protocol service document. It is normally stored as plain, XML-formatted text and describes collections of data that a compatible application can request from a remote service.
The format follows the idea of an Atom service document defined by the Atom Publishing Protocol. In Microsoft environments, ATOMSVC files are commonly associated with SQL Server Reporting Services, Power Pivot, Excel data feeds, OData services, and business intelligence workflows.
Definition sources:
Think of the file as a restaurant menu rather than the meal. It can list the available dishes and tell the waiter where to find them, but chewing on the menu will not improve your dinner.
Does an ATOMSVC File Contain the Actual Data?
Usually, no. An ATOMSVC file generally contains connection details, collection names, titles, and URLs pointing to the real feeds. The records you wantsales totals, inventory rows, customer information, or report resultsremain on the remote server until a compatible program requests them.
This is why an ATOMSVC file may be only a few kilobytes even when the connected report contains thousands or millions of records. Its job is to describe the available feeds, not to pack the entire database into your Downloads folder.
What Does the File Look Like?
When opened as text, a simplified ATOMSVC document may resemble the following example:
The important part is often the href value inside a collection element. That address tells an application where to request the associated feed. A real file may list several collections, especially when the original report contains multiple tables, charts, matrices, lists, or other data regions.
How ATOMSVC Files Are Created
ATOMSVC files are frequently produced when someone exports a report through the Data Feed option in SQL Server Reporting Services, also known as SSRS. The Reporting Services Atom rendering extension creates a service document listing the feeds generated from the report.
A basic table or gauge may generate one feed. More complicated regions, such as matrices, charts, and lists, can generate several. The ATOMSVC document organizes those feeds so applications such as Power Pivot or Power BI can discover and import them.
SSRS generation sources:
You may encounter an ATOMSVC file after:
- Exporting an SSRS report as a data feed
- Downloading data from a corporate reporting portal
- Receiving a business intelligence connection file from a coworker
- Working with an older OData or Atom-based reporting system
- Creating an Excel workbook connected to an external report feed
How to Open an ATOMSVC File
The correct method depends on whether you merely want to inspect the file or retrieve the data it references.
Method 1: Open It in a Text or XML Editor
Because an ATOMSVC file is text-based, the fastest way to inspect it is with a plain-text or XML editor. Suitable programs include:
- Notepad on Windows
- Visual Studio Code
- Notepad++
- Visual Studio’s XML editor
- TextEdit in plain-text mode on macOS
- Any code editor that supports XML
On Windows, right-click the file, select Open with, and choose an editor. On macOS, Control-click the file and use Open With. If the file appears on one long line, enable word wrapping or use an XML formatting feature to indent the elements.
Opening the document this way lets you view collection titles and feed addresses. It does not automatically download the connected report data.
Text and XML editing sources:
Method 2: Import the ATOMSVC File with Excel and Power Pivot
Microsoft Excel for Windows can use Power Pivot to import report feeds described by an ATOMSVC file. Exact menu names vary by Excel edition and release, but the general process is:
- Open the desktop version of Excel.
- Make sure the Microsoft Power Pivot add-in is available and enabled.
- Open the Power Pivot management window.
- Choose the option for importing from a data service, data feed, or existing connection.
- Select the saved ATOMSVC file or enter the service-document address.
- Choose the feed or feeds you want to import.
- Complete the import and load the results into the workbook’s data model.
Microsoft’s Reporting Services workflow specifically supports saving an Atom service document for later use and opening it through Power Pivot to import the report feed. Power Pivot availability can differ among Excel licenses, platforms, and organizational installations, so the feature may not appear in every edition.
Excel import sources:
If double-clicking the file merely opens XML text, that does not mean Excel is broken. It normally means the file association points to a text editor or browser. Start the import from inside Excel instead.
Method 3: Use the Feed URL in Power BI Desktop
Power BI may consume the Atom- or OData-compatible feed referenced by the document. A reliable approach is to extract the feed address first:
- Open the ATOMSVC file in a text editor.
- Search for
href=or<collection. - Copy the complete URL from the relevant collection.
- Open Power BI Desktop.
- Select Get data and choose OData Feed.
- Paste the URL and continue.
- Select the appropriate authentication method.
- Choose the available table or collection and load or transform it.
The service may require Windows credentials, an organizational account, basic authentication, an API credential, or anonymous access. Use the method specified by the report administrator rather than trying every option like a person testing keys on a mysterious basement door.
Power BI and authentication sources:
Method 4: Open It in a Web Browser
A browser can sometimes display the raw XML or offer to download the document again. This is useful for inspection but does not guarantee that the browser will retrieve and organize the linked data. Some browsers may show an XML tree, while others display unformatted text.
If a feed URL works only after signing in to a company portal or connecting to a VPN, opening the service document outside that environment may produce an access error.
Common ATOMSVC File Problems and Fixes
The Computer Says No App Can Open the File
Choose a text editor manually through the operating system’s Open with command. You do not need a dedicated “ATOMSVC Viewer” merely to inspect the contents.
The File Opens, but It Shows Only Code
That is normal. You are viewing XML markup. To retrieve the report records, import the document or its feed URL through Power Pivot, Power BI, or another application that supports the service.
The Feed Returns a 401 or Access-Denied Error
The server recognizes the request but requires valid authentication. Confirm which account should be used, whether your password has changed, and whether the report administrator has granted you access.
The URL Returns a 404 Error
A 404 response usually means the feed was moved, renamed, removed, or generated from a report that no longer exists. Ask the sender to export a new ATOMSVC document or provide the current service URL.
The Connection Works Only at the Office
The feed may be restricted to an internal network. Connect to the approved corporate VPN or access it from a managed device. Do not upload the file to random conversion websites, especially when it points to private company reports.
Power BI Cannot Find Any Tables
You may have entered a collection URL when the connector expects the service root, or entered the service root when the desired data exists deeper in the path. Test the URLs listed in the file and check whether the response contains a service document, feed, login page, or error message.
The Import Produces a Data-Type Error
Report columns may contain values that do not match the declared type. Decimal values, dates, blank fields, locale-specific number formats, and mixed text-and-number columns are common troublemakers. In Power Query, import the column as text first and then apply a deliberate type conversion.
The File Contains HTML Instead of XML
Sometimes a failed download saves a login page or server error page with the wrong extension. Open the file in a text editor. If it begins with HTML markup or contains phrases such as “sign in,” “access denied,” or “server error,” download it again after authenticating.
Can You Convert an ATOMSVC File?
An ATOMSVC file is not normally converted in the same way as a photo, video, or document. Since it mainly contains references to remote feeds, changing the extension to .csv or .xlsx will not magically summon the missing records.
The practical conversion workflow is:
- Open or import the ATOMSVC service document in compatible software.
- Allow the application to retrieve the connected data.
- Transform or clean the records as needed.
- Export the retrieved data as XLSX, CSV, JSON, XML, or another supported format.
You may save a copy of the service document as .xml or .txt for easier inspection. That changes how the text is labeled, not what the document does. The result remains a description of the service rather than a self-contained copy of the report.
ATOMSVC vs. Similar File Formats
| Format | Typical Purpose | Contains the Actual Data? |
|---|---|---|
| ATOMSVC | Describes one or more Atom or data-service collections | Usually no; it points to feeds |
| ATOM | Stores an Atom feed containing entries | Often yes |
| XML | General structured-text container | Depends on the application |
| CSV | Stores tabular values separated by delimiters | Yes |
| XLSX | Stores an Excel workbook | Usually yes, although it may also contain connections |
| ODC | Stores an Office data connection | Usually no; it describes a connection |
ATOMSVC and ATOM files are related but not interchangeable. The service document describes available collections, while an Atom feed generally carries entries from one of those collections. Their media types also differ: Atom service documents use application/atomsvc+xml, while standard Atom feeds commonly use application/atom+xml.
Atom and media-type sources:
Is an ATOMSVC File Safe?
An ATOMSVC file is plain text rather than an executable application, so opening it in a text editor does not normally run software. Nevertheless, the document can contain links to external or internal servers. Treat those addresses with the same caution you would apply to links in an email.
Before connecting, confirm that the file came from a trusted person or reporting system. Be especially careful when a URL contains long query strings, access tokens, session identifiers, or unfamiliar domains. Do not publish a private ATOMSVC file publicly, because its addresses may reveal internal server names, report paths, or sensitive access details.
Frequently Asked Questions
Can I Delete an ATOMSVC File?
Yes, provided you no longer need it to reconnect to the report feed. Deleting the local service document does not usually delete the original report or database because those resources remain on the server.
Why Did I Receive an ATOMSVC File Instead of Excel?
The report was probably exported using the Data Feed option rather than the Excel export option. Ask for an XLSX or CSV export when you need a self-contained snapshot instead of a refreshable connection.
Can I Open an ATOMSVC File on a Mac?
You can inspect it with TextEdit, Visual Studio Code, or another XML editor. Importing the connected data may require a compatible data tool, access to the feed URL, and support for the server’s authentication method.
Can Google Sheets Open an ATOMSVC File?
Google Sheets does not generally treat ATOMSVC files as ordinary spreadsheets. You would usually need to retrieve the linked data through another tool and export it to CSV or XLSX before uploading it to Sheets.
Is ATOMSVC the Same as OData?
No. OData is a broader web data-access protocol. An Atom service document is one XML-based way a service can describe available collections, particularly in older Microsoft reporting and OData-oriented workflows.
Practical Experience: A Typical ATOMSVC Rescue Mission
A common real-world encounter begins when someone emails a file called something like RegionalSales.atomsvc with the cheerful instruction, “Here is the spreadsheet.” The recipient double-clicks it, sees a wall of XML, and concludes that either the export failed or the accounting department has started communicating in hieroglyphics.
The first useful step is not installing five mysterious file-opening utilities. It is opening the document in a trusted text editor and checking what is actually inside. A healthy ATOMSVC file typically begins with an XML declaration and contains a service, workspace, and one or more collection elements. Each collection usually has a recognizable title and an href address.
In one typical support scenario, the file listed three collections: a sales table, a regional summary, and a chart series. The user had been copying the first URL into a browser and receiving a login page. That looked like a broken feed, but the real issue was authentication. The browser session used one account, while the reporting server expected the user’s corporate Windows credentials.
After connecting through the approved VPN and selecting the organizational authentication option in the data connector, the feed loaded correctly. The three collections appeared as separate tables. The user selected the sales table, removed two unnecessary ID fields, corrected a date column that had been imported as text, and loaded the results into a workbook.
The next surprise arrived during refresh. A column that usually contained whole numbers suddenly included a decimal value. The report feed exposed inconsistent types, and the refresh failed. Importing the troublesome column as text, replacing invalid values, and then converting it to a decimal number solved the problem. Data feeds are wonderfully automatic right up until one row decides to become an avant-garde artist.
Another recurring issue is stale service documents. An ATOMSVC file downloaded six months ago may still contain a perfectly valid XML structure while pointing to a report path that no longer exists. No amount of extension renaming, browser switching, or motivational speaking will repair a deleted server endpoint. The correct fix is to obtain a newly exported file or current feed URL from the report owner.
The most important practical lesson is to decide whether you need a live connection or a static copy. Use the ATOMSVC workflow when the report should refresh from its source. Request CSV or XLSX when you simply need today’s values and want a file that opens without network access, authentication prompts, or corporate VPN gymnastics.
Once that distinction is understood, ATOMSVC files stop looking mysterious. They are lightweight connection maps designed to help reporting tools discover remote data. Open them as text to investigate, import them through a compatible data application to retrieve the records, and export the results when a portable spreadsheet is the better tool for the job.
Research citations:
