Importing a CSV file

With Spreadsheet.com, it's easy to import CSV files 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 a CSV File

You can import an existing spreadsheet via your Spreadsheet.com homepage.

Create-New-Workbook-Locate.jpg

Here, create new workbooks from the top navigation bar (1) or from directly within a workspace (2) or folder (3).

Each button will open the New Workbook dialog where you can can create a new workbook three different ways: create a new workbook from a template, create a new blank workbook, or import an existing workbook from elsewhere. Select "Import CSV file" from the bottom of the dialog.

CSV-Import-Locate.jpg

Clicking here will open the Import workbook dialog from where you can select the file to import, name your imported workbook, and specify the workbook owner and location.

Import-Workbook.jpg

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 Quick Start 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.