Export a sheet with attachments preserving the row references

For various reasons, it may be needed to export the sheet with all their attachments while preserving the knowledge of which attachment belongs to which row.

Solution examples:

1) A PDF binder where a click on the link would open the attachment, which is embedded in the binder.

2) A ZIP archive containing an Excel or HTML file with relative links to attachments stored in the subfolder in the same directory.

3) An MHT file with attachments embedded in it the same way images can be embedded (using Base-64 encoding).

Sign in to vote!

Find more posts tagged with

On Radar

Comments

Richard Heath

When a Sheet is currently exported to Excel, there is no reference to any attachments that may have resided in the Sheet.

As a minimum, it would be good to have a column in the XLSX that displays the name of the attachments included in each row.

Federico Prado

This is a great idea! any news from the smartsheet supoort team to make this happen?

AmaiaD

Even if we could just have a column on the Smartsheet with the attachment filename would help!

AmaiaD

With the advancement of AI and the possibility to use it for data analysis we are hindered by not having a way to identify which attachments correspond to which row, when exporting a backup. The attachments are downloaded in a ZIP file with no reference to the row they relate to. And the Smartsheet data does not have a field that contains the file name which could also be used to cross-reference. It has been a feature that has been requested many times over the years with no progress - could the team relook at what options are viable?

Breytejj

All attachments must start with the Row number when the attachments are down loaded in zip format to make it easier to find downloaded documents if don for complete list.

Regards

Breytejj

TJA

This is not a new idea and you are well aware of it but not being able to produce a report that includes the row info ALONG WITH the associated attachment is terrible. It's just so cumbersome and not practical to use.

TJA

See App Site Audit Pro for reference on producing a useable report.

Interrogation

Would very much like to see this… even if it is only an additional tag with a row identifier that is added to the file name.

Jess S PDX

Found this while searching for solutions. I'm unable to download bulk attachments for a large report-known bug. Additionally, while vetting work arounds Excel export doesn't show what rows have attachments to be able to sort and filter so we can focus on those. We'll need to dedicate ~45 hours to manual download of each file, renaming, and ensuring that we know what client it's associated with is made much more difficult and time consuming.

J.Frederiksen

I would like to be able to use attached images during Export so that images are tied up in rows. or if the image gets the same name as the row, if you have many rows with many images it is not easy to find your way around during export

It would also be great if you could add files to a specific cell or attach them when generating a document.

pwillars_smwllc.com

The ability to somehow link the attachment info to any file export is still desperately needed.

lbillows

Agreed! I had recently posted this very question to the Community board and subsequently opened a ticket with Smartsheet Support who said there is no way to associate attachments to their respective line when downloaded.

This absolutely has my vote as a function long overdue!

It's great to see that it's 'On Radar' as of 01/31/25 - but Smartsheet, please make it happen!!

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…