Importing from other data sources

With Spreadsheet.com, it's easy to import your existing spreadsheets and then add in unique Spreadsheet.com features, like views, data types, and related rows.

Importing workbooks retains data, styling, formatting, formulas, and more. Currently, you can import Excel or CSV files, and exports from other spreadsheet software, like Google Sheets.

Use imported spreadsheets to get up and running quickly, pulling in existing formatting or reusing complex formulas. Spreadsheet.com is a standards-compliant spreadsheet platform that includes powerful collaborative features, allowing you to take your spreadsheets further than before.

How does Spreadsheet.com convert data?

When importing, Spreadsheet.com retains data, styling, formatting, formulas, cross-sheet formulas, images, named ranges, and more. In Spreadsheet.com, Excel or Google Sheets are converted to Worksheets, to which you can add views

One unique aspect of Spreadsheet.com is that it converts cells and columns with custom "Number Formats" (Excel) or "Formats" (Google Sheets) to Data Types. Data types allow you fine control over formatting and allow for unique formulas and data types (like Duration).

How to Import Files from Other Sources

You can import an existing spreadsheet via your Workspaces sidebar.

How to Create a New Document

You can create new documents from anywhere in Spreadsheet.com via the Workspaces sidebar.

  1. Open the Workspaces sidebar by clicking on your workspace icon
  2. Click the blue +New button above the search bar
  3. Select the type of new document you want to create
  4. Assign your document a name, specify a location, and click Save

Selecting "Import from CSV" or "Import from Excel" will open the Import workbook dialog, where you can select the file to import, name the imported workbook, and assign it a location.

import-workbook-dialog.png

Once you've configured these options, click the blue Import button in the bottom right corner to complete the upload process.

Which spreadsheets can be imported into Spreadsheet.com?

Spreadsheet.com allows a variety of file formats to be imported, including:

  • Excel files with the extensions .XLS and .XLSX
  • Excel templates with the extensions .XLT and .XLTX
  • Other spreadsheets with the extensions .CSV and .TSV

Imported spreadsheets are subject to row limitations based on your plan. For more information, see our article on Workbook Storage and Size Limits, or read more about Spreadsheet.com plans.

Check out our article on Tips for Importing Spreadsheets for more insight into how to prepare a spreadsheet for import, especially if converting some data to Spreadsheet.com's unique data types.