With Spreadsheet.com, it's easy to import other 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, as shown below.
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).
Importing Excel and CSV Files
Spreadsheet.com makes it easy to import Excel and CSV files that retain all data, formulas, formatting, and more. You can import an existing spreadsheet via your Spreadsheet.com homepage.
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" or "Import from Excel" from the bottom of the dialog.
Clicking either option 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.
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.
Importing from Google Sheets and Other Platforms
Currently, Spreadsheet.com does not support importing directly from other spreadsheet platforms like Google Sheets. However, you can export spreadsheets from these platforms as either Excel files or CSV files and then import the exported documents into Spreadsheet.com.
To export a spreadsheet from Google Sheets, open the "File" menu from the top menu bar and hover over "Download" to open the secondary file format menu. From here, select one of the file types compatible with Spreadsheet.com, download your spreadsheet, and then upload it to Spreadsheet.com.
Importing Templates
When importing template type spreadsheets (XLT and XLTX file types), Spreadsheet.com converts these to regular workbooks. You can then turn them (or any workbook) into a Spreadsheet.com template.
Once you've imported a spreadsheet, try collaborating with others in your Workbook, adding in custom views like Kanban views, or relating worksheets to refer to data across workbooks.